package com.xie.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xie.pojo.Paitient;
import com.xie.pojo.Vo.PaitientVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PaitientDao extends BaseMapper<Paitient> {

@Select("select  personnel.emp_no,personnel.emp_name,paitient.paitient_id,paitient.paitient_name,paitient.paitient_gender,paitient.paitient_state,paitient.paitient_dateStart FROM personnel,paitient WHERE personnel.emp_no = paitient.paitient_doc")
    List<PaitientVo> findPP(); //查询指定医生诊断的病人

}
